Post Profile Facebook Dataset

Dataset statistics

Number of variables	15
Number of observations	99003
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	6
Duplicate rows (%)	< 0.1%
Total size in memory	6.8 MiB
Average record size in memory	72.0 B

Variable types

Numeric	12
DateTime	1
Categorical	2

Alerts

Dataset has 6 (< 0.1%) duplicate rows	Duplicates
`tenure` has a high cardinality: 2427 distinct values	High cardinality
`age` is highly correlated with `dob_year`	High correlation
`dob_year` is highly correlated with `age`	High correlation
`friend_count` is highly correlated with `friendships_initiated`	High correlation
`friendships_initiated` is highly correlated with `friend_count`	High correlation
`likes` is highly correlated with `mobile_likes` and 1 other fields	High correlation
`likes_received` is highly correlated with `mobile_likes_received` and 1 other fields	High correlation
`mobile_likes` is highly correlated with `likes`	High correlation
`mobile_likes_received` is highly correlated with `likes_received` and 1 other fields	High correlation
`www_likes` is highly correlated with `likes`	High correlation
`www_likes_received` is highly correlated with `likes_received` and 1 other fields	High correlation
`likes_received` is highly skewed (γ1 = 112.0745682)	Skewed
`mobile_likes_received` is highly skewed (γ1 = 107.5312999)	Skewed
`www_likes_received` is highly skewed (γ1 = 126.257317)	Skewed
`friend_count` has 1962 (2.0%) zeros	Zeros
`friendships_initiated` has 2997 (3.0%) zeros	Zeros
`likes` has 22308 (22.5%) zeros	Zeros
`likes_received` has 24428 (24.7%) zeros	Zeros
`mobile_likes` has 35056 (35.4%) zeros	Zeros
`mobile_likes_received` has 30003 (30.3%) zeros	Zeros
`www_likes` has 60999 (61.6%) zeros	Zeros
`www_likes_received` has 36864 (37.2%) zeros	Zeros

Reproduction

Analysis started	2022-11-01 12:49:07.442647
Analysis finished	2022-11-01 12:49:32.224069
Duration	24.78 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	101
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.28022383

Minimum	13
Maximum	113
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	13
5-th percentile	15
Q1	20
median	28
Q3	50
95-th percentile	90
Maximum	113
Range	100
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	22.58974831
Coefficient of variation (CV)	0.6059445462
Kurtosis	1.561446767
Mean	37.28022383
Median Absolute Deviation (MAD)	10
Skewness	1.415260654
Sum	3690854
Variance	510.2967289
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	5196	5.2%
23	4404	4.4%
19	4391	4.4%
20	3769	3.8%
21	3671	3.7%
25	3641	3.7%
17	3283	3.3%
16	3086	3.1%
22	3032	3.1%
24	2827	2.9%
Other values (91)	61703	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13	484	0.5%
14	1925	1.9%
15	2618	2.6%
16	3086	3.1%
17	3283	3.3%
18	5196	5.2%
19	4391	4.4%
20	3769	3.8%
21	3671	3.7%
22	3032	3.1%

Value	Count	Frequency (%)
113	202	0.2%
112	18	< 0.1%
111	18	< 0.1%
110	15	< 0.1%
109	9	< 0.1%
108	1661	1.7%
107	98	0.1%
106	125	0.1%
105	80	0.1%
104	73	0.1%

date_of_birth
Date

Distinct	23151
Distinct (%)	23.4%
Missing	0
Missing (%)	0.0%
Memory size	773.6 KiB

Minimum	1900-01-01 00:00:00
Maximum	2000-10-27 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

dob_day
Real number (ℝ_≥0)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.53040817

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	14
Q3	22
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.015606359
Coefficient of variation (CV)	0.6204647697
Kurtosis	-1.188960111
Mean	14.53040817
Median Absolute Deviation (MAD)	8
Skewness	0.1078407568
Sum	1438554
Variance	81.28115802
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	7900	8.0%
10	4030	4.1%
15	3555	3.6%
5	3545	3.6%
12	3413	3.4%
2	3409	3.4%
3	3291	3.3%
17	3266	3.3%
20	3263	3.3%
14	3219	3.3%
Other values (21)	60112	60.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7900	8.0%
2	3409	3.4%
3	3291	3.3%
4	3217	3.2%
5	3545	3.6%
6	3108	3.1%
7	3010	3.0%
8	3202	3.2%
9	3003	3.0%
10	4030	4.1%

Value	Count	Frequency (%)
31	1507	1.5%
30	2530	2.6%
29	2508	2.5%
28	2955	3.0%
27	2755	2.8%
26	2753	2.8%
25	3217	3.2%
24	2807	2.8%
23	2864	2.9%
22	2838	2.9%

dob_year
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	101
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1975.719776

Minimum	1900
Maximum	2000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	1900
5-th percentile	1923
Q1	1963
median	1985
Q3	1993
95-th percentile	1998
Maximum	2000
Range	100
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	22.58974831
Coefficient of variation (CV)	0.01143368032
Kurtosis	1.561446767
Mean	1975.719776
Median Absolute Deviation (MAD)	10
Skewness	-1.415260654
Sum	195602185
Variance	510.2967289
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1995	5196	5.2%
1990	4404	4.4%
1994	4391	4.4%
1993	3769	3.8%
1992	3671	3.7%
1988	3641	3.7%
1996	3283	3.3%
1997	3086	3.1%
1991	3032	3.1%
1989	2827	2.9%
Other values (91)	61703	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	202	0.2%
1901	18	< 0.1%
1902	18	< 0.1%
1903	15	< 0.1%
1904	9	< 0.1%
1905	1661	1.7%
1906	98	0.1%
1907	125	0.1%
1908	80	0.1%
1909	73	0.1%

Value	Count	Frequency (%)
2000	484	0.5%
1999	1925	1.9%
1998	2618	2.6%
1997	3086	3.1%
1996	3283	3.3%
1995	5196	5.2%
1994	4391	4.4%
1993	3769	3.8%
1992	3671	3.7%
1991	3032	3.1%

dob_month
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.283365151

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.529671569
Coefficient of variation (CV)	0.5617485987
Kurtosis	-1.240397572
Mean	6.283365151
Median Absolute Deviation (MAD)	3
Skewness	0.03129550742
Sum	622072
Variance	12.45858138
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	11772	11.9%
10	8476	8.6%
5	8271	8.4%
8	8266	8.3%
3	8110	8.2%
7	8021	8.1%
9	7939	8.0%
12	7894	8.0%
4	7810	7.9%
2	7632	7.7%
Other values (2)	14812	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11772	11.9%
2	7632	7.7%
3	8110	8.2%
4	7810	7.9%
5	8271	8.4%
6	7607	7.7%
7	8021	8.1%
8	8266	8.3%
9	7939	8.0%
10	8476	8.6%

Value	Count	Frequency (%)
12	7894	8.0%
11	7205	7.3%
10	8476	8.6%
9	7939	8.0%
8	8266	8.3%
7	8021	8.1%
6	7607	7.7%
5	8271	8.4%
4	7810	7.9%
3	8110	8.2%

gender
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	773.6 KiB

male	58574
female	40254
NA	175

Length

Max length	6
Median length	4
Mean length	4.809652233
Min length	2

Characters and Unicode

Total characters	476170
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	male
2nd row	female
3rd row	male
4th row	female
5th row	male

Common Values

Value	Count	Frequency (%)
male	58574	59.2%
female	40254	40.7%
NA	175	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
male	58574	59.2%
female	40254	40.7%
na	175	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%
N	175	< 0.1%
A	175	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	475820	99.9%
Uppercase Letter	350	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%

Uppercase Letter

Value	Count	Frequency (%)
N	175	50.0%
A	175	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	476170	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%
N	175	< 0.1%
A	175	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	476170	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%
N	175	< 0.1%
A	175	< 0.1%

tenure
Categorical

HIGH CARDINALITY

Distinct	2427
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	773.6 KiB

300	173
303	170
242	164
272	163
257	161
Other values (2422)	98172

Length

Max length	4
Median length	3
Mean length	3.031595002
Min length	1

Characters and Unicode

Total characters	300137
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	133 ?
Unique (%)	0.1%

Sample

1st row	266
2nd row	6
3rd row	13
4th row	93
5th row	82

Common Values

Value	Count	Frequency (%)
300	173	0.2%
303	170	0.2%
242	164	0.2%
272	163	0.2%
257	161	0.2%
297	161	0.2%
280	160	0.2%
285	160	0.2%
278	158	0.2%
284	158	0.2%
Other values (2417)	97375	98.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
300	173	0.2%
303	170	0.2%
242	164	0.2%
272	163	0.2%
257	161	0.2%
297	161	0.2%
280	160	0.2%
285	160	0.2%
278	158	0.2%
284	158	0.2%
Other values (2417)	97375	98.4%

Most occurring characters

Value	Count	Frequency (%)
1	46163	15.4%
2	36960	12.3%
3	34833	11.6%
4	33047	11.0%
5	30079	10.0%
6	27470	9.2%
7	24933	8.3%
8	23035	7.7%
9	21940	7.3%
0	21673	7.2%
Other values (2)	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	300133	> 99.9%
Uppercase Letter	4	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	46163	15.4%
2	36960	12.3%
3	34833	11.6%
4	33047	11.0%
5	30079	10.0%
6	27470	9.2%
7	24933	8.3%
8	23035	7.7%
9	21940	7.3%
0	21673	7.2%

Uppercase Letter

Value	Count	Frequency (%)
N	2	50.0%
A	2	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	300133	> 99.9%
Latin	4	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	46163	15.4%
2	36960	12.3%
3	34833	11.6%
4	33047	11.0%
5	30079	10.0%
6	27470	9.2%
7	24933	8.3%
8	23035	7.7%
9	21940	7.3%
0	21673	7.2%

Latin

Value	Count	Frequency (%)
N	2	50.0%
A	2	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	300137	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	46163	15.4%
2	36960	12.3%
3	34833	11.6%
4	33047	11.0%
5	30079	10.0%
6	27470	9.2%
7	24933	8.3%
8	23035	7.7%
9	21940	7.3%
0	21673	7.2%
Other values (2)	4	< 0.1%

friend_count
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	2562
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	196.3507873

Minimum	0
Maximum	4923
Zeros	1962
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	31
median	82
Q3	206
95-th percentile	720
Maximum	4923
Range	4923
Interquartile range (IQR)	175

Descriptive statistics

Standard deviation	387.304229
Coefficient of variation (CV)	1.972511719
Kurtosis	50.09427289
Mean	196.3507873
Median Absolute Deviation (MAD)	64
Skewness	6.059008484
Sum	19439317
Variance	150004.5658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1962	2.0%
1	1816	1.8%
2	1117	1.1%
3	860	0.9%
5	789	0.8%
4	749	0.8%
10	737	0.7%
24	732	0.7%
6	720	0.7%
29	719	0.7%
Other values (2552)	88802	89.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1962	2.0%
1	1816	1.8%
2	1117	1.1%
3	860	0.9%
4	749	0.8%
5	789	0.8%
6	720	0.7%
7	671	0.7%
8	718	0.7%
9	700	0.7%

Value	Count	Frequency (%)
4923	1	< 0.1%
4917	1	< 0.1%
4863	1	< 0.1%
4845	1	< 0.1%
4844	1	< 0.1%
4826	1	< 0.1%
4817	1	< 0.1%
4803	1	< 0.1%
4797	1	< 0.1%
4794	1	< 0.1%

friendships_initiated
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1519
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	107.4524711

Minimum	0
Maximum	4144
Zeros	2997
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	17
median	46
Q3	117
95-th percentile	418
Maximum	4144
Range	4144
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	188.786951
Coefficient of variation (CV)	1.756934475
Kurtosis	42.53560096
Mean	107.4524711
Median Absolute Deviation (MAD)	36
Skewness	5.150757415
Sum	10638117
Variance	35640.51287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2997	3.0%
1	2212	2.2%
2	1551	1.6%
3	1355	1.4%
4	1352	1.4%
6	1328	1.3%
5	1328	1.3%
11	1319	1.3%
8	1314	1.3%
13	1279	1.3%
Other values (1509)	82968	83.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2997	3.0%
1	2212	2.2%
2	1551	1.6%
3	1355	1.4%
4	1352	1.4%
5	1328	1.3%
6	1328	1.3%
7	1237	1.2%
8	1314	1.3%
9	1245	1.3%

Value	Count	Frequency (%)
4144	1	< 0.1%
3654	1	< 0.1%
3594	1	< 0.1%
3538	1	< 0.1%
3415	1	< 0.1%
3238	1	< 0.1%
3233	1	< 0.1%
3086	1	< 0.1%
3078	1	< 0.1%
3024	1	< 0.1%

likes
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	2924
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	156.0787855

Minimum	0
Maximum	25111
Zeros	22308
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	11
Q3	81
95-th percentile	726
Maximum	25111
Range	25111
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	572.2806808
Coefficient of variation (CV)	3.666614134
Kurtosis	200.4456878
Mean	156.0787855
Median Absolute Deviation (MAD)	11
Skewness	11.02370356
Sum	15452268
Variance	327505.1777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22308	22.5%
1	6928	7.0%
2	4434	4.5%
3	3240	3.3%
4	2507	2.5%
5	2027	2.0%
6	1806	1.8%
7	1618	1.6%
8	1430	1.4%
9	1381	1.4%
Other values (2914)	51324	51.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22308	22.5%
1	6928	7.0%
2	4434	4.5%
3	3240	3.3%
4	2507	2.5%
5	2027	2.0%
6	1806	1.8%
7	1618	1.6%
8	1430	1.4%
9	1381	1.4%

Value	Count	Frequency (%)
25111	1	< 0.1%
21652	1	< 0.1%
16732	1	< 0.1%
16583	1	< 0.1%
14799	1	< 0.1%
14355	1	< 0.1%
14050	1	< 0.1%
14039	1	< 0.1%
13692	1	< 0.1%
13622	1	< 0.1%

likes_received
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	2681
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	142.6893629

Minimum	0
Maximum	261197
Zeros	24428
Zeros (%)	24.7%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	8
Q3	59
95-th percentile	561
Maximum	261197
Range	261197
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	1387.919613
Coefficient of variation (CV)	9.726861091
Kurtosis	17384.94
Mean	142.6893629
Median Absolute Deviation (MAD)	8
Skewness	112.0745682
Sum	14126675
Variance	1926320.851
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	24428	24.7%
1	7305	7.4%
2	4541	4.6%
3	3347	3.4%
4	2669	2.7%
5	2373	2.4%
6	1873	1.9%
7	1680	1.7%
8	1538	1.6%
9	1351	1.4%
Other values (2671)	47898	48.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	24428	24.7%
1	7305	7.4%
2	4541	4.6%
3	3347	3.4%
4	2669	2.7%
5	2373	2.4%
6	1873	1.9%
7	1680	1.7%
8	1538	1.6%
9	1351	1.4%

Value	Count	Frequency (%)
261197	1	< 0.1%
178166	1	< 0.1%
152014	1	< 0.1%
106025	1	< 0.1%
82623	1	< 0.1%
53534	1	< 0.1%
52964	1	< 0.1%
45633	1	< 0.1%
42449	1	< 0.1%
39536	1	< 0.1%

mobile_likes
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	2396
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106.1162995

Minimum	0
Maximum	25111
Zeros	35056
Zeros (%)	35.4%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	46
95-th percentile	481.9
Maximum	25111
Range	25111
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	445.2529851
Coefficient of variation (CV)	4.195896268
Kurtosis	360.9885806
Mean	106.1162995
Median Absolute Deviation (MAD)	4
Skewness	14.16123656
Sum	10505832
Variance	198250.2207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35056	35.4%
1	6297	6.4%
2	3941	4.0%
3	2917	2.9%
4	2265	2.3%
5	1794	1.8%
6	1598	1.6%
7	1395	1.4%
8	1212	1.2%
9	1149	1.2%
Other values (2386)	41379	41.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35056	35.4%
1	6297	6.4%
2	3941	4.0%
3	2917	2.9%
4	2265	2.3%
5	1794	1.8%
6	1598	1.6%
7	1395	1.4%
8	1212	1.2%
9	1149	1.2%

Value	Count	Frequency (%)
25111	1	< 0.1%
21652	1	< 0.1%
16732	1	< 0.1%
14039	1	< 0.1%
13529	1	< 0.1%
12934	1	< 0.1%
12639	1	< 0.1%
12104	1	< 0.1%
12083	1	< 0.1%
11959	1	< 0.1%

mobile_likes_received
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	2004
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.1204913

Minimum	0
Maximum	138561
Zeros	30003
Zeros (%)	30.3%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	33
95-th percentile	317
Maximum	138561
Range	138561
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	839.8894437
Coefficient of variation (CV)	9.984362083
Kurtosis	15522.64932
Mean	84.1204913
Median Absolute Deviation (MAD)	4
Skewness	107.5312999
Sum	8328181
Variance	705414.2777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	30003	30.3%
1	8243	8.3%
2	4948	5.0%
3	3608	3.6%
4	2944	3.0%
5	2383	2.4%
6	2022	2.0%
7	1745	1.8%
8	1521	1.5%
9	1437	1.5%
Other values (1994)	40149	40.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	30003	30.3%
1	8243	8.3%
2	4948	5.0%
3	3608	3.6%
4	2944	3.0%
5	2383	2.4%
6	2022	2.0%
7	1745	1.8%
8	1521	1.5%
9	1437	1.5%

Value	Count	Frequency (%)
138561	1	< 0.1%
131244	1	< 0.1%
89911	1	< 0.1%
73333	1	< 0.1%
43410	1	< 0.1%
30754	1	< 0.1%
30387	1	< 0.1%
27353	1	< 0.1%
20770	1	< 0.1%
18925	1	< 0.1%

www_likes
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1726
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.96242538

Minimum	0
Maximum	14865
Zeros	60999
Zeros (%)	61.6%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	7
95-th percentile	208
Maximum	14865
Range	14865
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	285.5601519
Coefficient of variation (CV)	5.715498191
Kurtosis	449.1484832
Mean	49.96242538
Median Absolute Deviation (MAD)	0
Skewness	16.91102529
Sum	4946430
Variance	81544.60033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60999	61.6%
1	4697	4.7%
2	2760	2.8%
3	1948	2.0%
4	1419	1.4%
5	1202	1.2%
6	1081	1.1%
7	897	0.9%
8	792	0.8%
9	757	0.8%
Other values (1716)	22451	22.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60999	61.6%
1	4697	4.7%
2	2760	2.8%
3	1948	2.0%
4	1419	1.4%
5	1202	1.2%
6	1081	1.1%
7	897	0.9%
8	792	0.8%
9	757	0.8%

Value	Count	Frequency (%)
14865	1	< 0.1%
12903	1	< 0.1%
11077	1	< 0.1%
10763	1	< 0.1%
10627	1	< 0.1%
10539	1	< 0.1%
10255	1	< 0.1%
10232	1	< 0.1%
9902	1	< 0.1%
9431	1	< 0.1%

www_likes_received
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	1636
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.56883125

Minimum	0
Maximum	129953
Zeros	36864
Zeros (%)	37.2%
Negative	0
Negative (%)	0.0%
Memory size	386.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	20
95-th percentile	227
Maximum	129953
Range	129953
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	601.416348
Coefficient of variation (CV)	10.26853934
Kurtosis	23812.2491
Mean	58.56883125
Median Absolute Deviation (MAD)	2
Skewness	126.257317
Sum	5798490
Variance	361701.6237
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	36864	37.2%
1	8513	8.6%
2	5111	5.2%
3	3586	3.6%
4	2828	2.9%
5	2317	2.3%
6	1918	1.9%
7	1602	1.6%
8	1445	1.5%
9	1373	1.4%
Other values (1626)	33446	33.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	36864	37.2%
1	8513	8.6%
2	5111	5.2%
3	3586	3.6%
4	2828	2.9%
5	2317	2.3%
6	1918	1.9%
7	1602	1.6%
8	1445	1.5%
9	1373	1.4%

Value	Count	Frequency (%)
129953	1	< 0.1%
62103	1	< 0.1%
39605	1	< 0.1%
39213	1	< 0.1%
34039	1	< 0.1%
32692	1	< 0.1%
29337	1	< 0.1%
23147	1	< 0.1%
22644	1	< 0.1%
15096	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	age	date_of_birth	dob_day	dob_year	dob_month	gender	tenure
0	14	1999-11-19	19	1999	11	male	266
1	14	1999-11-02	2	1999	11	female	6
2	14	1999-11-16	16	1999	11	male	13
3	14	1999-12-25	25	1999	12	female	93
4	14	1999-12-04	4	1999	12	male	82
5	14	1999-12-01	1	1999	12	male	15
6	13	2000-01-14	14	2000	1	male	12
7	13	2000-01-04	4	2000	1	female	0
8	13	2000-01-01	1	2000	1	male	81
9	13	2000-02-02	2	2000	2	male	171

Last rows

	age	date_of_birth	dob_day	dob_year	dob_month	gender	tenure	friend_count	friendships_initiated	likes	likes_received	mobile_likes	mobile_likes_received	www_likes	www_likes_received
98993	19	1994-08-15	15	1994	8	male	394	4538	4144	4501	15088	4435	5961	66	9127
98994	20	1993-01-04	4	1993	1	female	402	1988	332	7351	106025	7248	73333	103	32692
98995	20	1993-10-09	9	1993	10	female	699	3611	973	4507	7768	4414	6909	93	859
98996	24	1989-04-25	25	1989	4	female	182	2938	1272	6018	17765	5843	11708	175	6057
98997	28	1985-12-14	14	1985	12	female	290	2218	1618	4626	10268	4290	4250	336	6018
98998	68	1945-04-04	4	1945	4	female	541	2118	341	3996	18089	3505	11887	491	6202
98999	18	1995-03-12	12	1995	3	female	21	1968	1720	4401	13412	4399	10592	2	2820
99000	15	1998-05-10	10	1998	5	female	111	2002	1524	11959	12554	11959	11462	0	1092
99001	23	1990-04-11	11	1990	4	female	416	2560	185	4506	6516	4506	5760	0	756
99002	39	1974-05-15	15	1974	5	female	397	2049	768	9410	12443	9410	9530	0	2913

Most frequently occurring

	age	date_of_birth	dob_day	dob_year	dob_month	gender	tenure	friend_count	friendships_initiated	# duplicates
2	25	1988-01-01	1	1988	1	male	21	0	0	4
0	23	1990-01-01	1	1990	1	male	507	1	1	2
1	25	1988-01-01	1	1988	1	male	0	0	0	2
3	25	1988-01-01	1	1988	1	male	33	0	0	2
4	26	1987-01-01	1	1987	1	male	500	2	2	2
5	33	1980-01-01	1	1980	1	male	17	0	0	2

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring